package com.sto.stoapp.db.constant;

/**
 * 错误单号表
 * 
 * @author Administrator
 * 
 */
public interface ErrorRecordConstant extends StoBaseConstant {

	public static String RESP_PDA_UUID = "resp_pda_uuid";
	public static String RESP_WAY_BILL_NO = "resp_way_bill_no";
	public static String RESP_OP_CODE = "resp_op_code";
	public static String RESP_ERROR_CODE = "resp_error_code";
	public static String RESP_ERROR_DESCRIPTION = "resp_error_description";

	public static String TIME = "time";

	public static String SITE_CODE = "site_code";
	/**
	 * 错误单号表
	 */
	public static String ERROR_RECORD_TABLE = "error_record_table";
	/**
	 * 创建错误单号表
	 */
	public static final String CREATE_ERROR_RECORD_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ ERROR_RECORD_TABLE
			+ "("
			+ RESP_PDA_UUID
			+ "  text PRIMARY KEY "
			+ ","
			+ RESP_WAY_BILL_NO
			+ " text "
			+ ","
			+ RESP_OP_CODE
			+ " text "
			+ ","
			+ RESP_ERROR_CODE
			+ " text"
			+ ","
			+ SITE_CODE
			+ " text"
			+ ","
			+ RESP_ERROR_DESCRIPTION
			+ " text"
			+ ","
			+ TIME
			+ " text "
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";
}
